Populate Excel Table Rows From Another Excel Table Column Header

Question

Hello,

I have two tables and would like the column headers from one table to populate the rows of another column. The purpose of this is to be able to manually populate data in both tables. The underlined areas is where I would like to manually enter data.

Table 1

Cat	Dog	Turtle	Rabbit
3	1	1	6

Table 2

Cat	Mammal
Dog	Mammal
Turtle	Reptile
Rabbit	Mammal

Answer 1

Excel 365 Pro Plus with Power Query.

Transpose and categorize.

No formulas, no VBA macro.

https://www.mediafire.com/file/6oo2139ek22cyo7/11_03_21b.xlsx/file

https://www.mediafire.com/file/gn3bh081rvv9n60/11_03_21b.pdf/file

Answer 2

I am still looking for help. In my example (maybe a poor example) I am trying to populate the values from the headers in Table 1 as Column A in Table 2 then manually enter data in Column B on Table 2. In the great example from Herbert I don't believe there was a way to manually enter data in the resulting table.

Answer 3

Hi KAmstutz,

I am writing to follow up on this case. If you still need any help, let me know when you have time.

Regards,

Neha

Answer 4

Hi,

What end result are you expecting?