How to get one value per row from table?

[Erza]

Hi,
I'm not able to find a way how to get data out in the way I would need from a very big table that I've created from various data sources.
I'm looking to get one value per project per row from this table, as I tried to show in the example. Any ideas how to do this? Tried pivoting, but could not make it work.
I have Excel for Mac in use, version 16.16.27 (201012).
Many thanks in advance for any help!

 

[Erza]

Sorry, I will try to explain a bit better : to have project 1, data 1 in one row, project 1, data 2 on the second row and so on is what I would need.
In order to get all this data - one value per row- from columns B-ZZ for 1000 projects, what could be the easiest way to do this?

 

[Fluff]

Probably with VBA, but as you are on a Mac & there differences between VBA on Mac & PC I can't help.

 

[Erza]

Probably with VBA, but as you are on a Mac & there differences between VBA on Mac & PC I can't help.

Ok, thanks for trying to help me with this! I'll try to think of some other approach to solve this. Thanks again!

 

[Fluff]

You're welcome