Dynamic list of all table headers fromanother tab

Hi all,

I have a table that lists project names across the top (i.e. project 1, project 2, project 3, etc).

I would like a an automatically generated list on another tab that lists all of these project names down a column.

I especially need this list to continue to add new project names IF I add a new column to the original table with a new project (aka adding a Project 4 column)

Any leads??

Assuming your project names are in row 1 of Sheet1, you could use this formula in A2 of Sheet2:

=IF(ROWS($1:1)>COUNTA(Sheet1!$1:$1),"",INDEX(Sheet1!$1:$1,ROWS($1:1)))

then copy down as far as you like.

Hope this helps.

Pete

Thank you all!!

I tried:
=INDEX(Sheet1!$A$1:$Z$1,1,ROW())

and it worked but required me to drag down the function every time a new column was added to the master table. I am hoping for something a bit more automatic.

I have attached a simple sample workbook so you can see what I am going for under the "Report - All projects" Tav
I am hoping to only ever edit the master tab and have the report tab automatically add the new project name, if a column is added.

Means a lot to get help on this! I've been at it for 7 hours today and can't seem to get it.

I see what you mean! And I think you're right - I am going to need to use a macro.

I haven't ever used one before but I think it's necessary. Do you think I could do one simply?

maggieapple . You can convert data to simple table and use pivote table based on it. PowerQuery could be use also