How to get one value per row from table?

Erza

New Member
Joined
Nov 4, 2005
Messages
16
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!
 

Attachments

  • Screenshot 2020-12-01 at 14.38.36.png
    Screenshot 2020-12-01 at 14.38.36.png
    42.5 KB · Views: 15

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
How about
Excel Formula:
=INDEX($B$2:$E$6,MATCH(A8,$A$2:$A$6,0),MATCH(B8,$B$1:$E$1,0))
 
Upvote 0
Here's what I get when I try to copy this formula, I'm surely missing now something?
 

Attachments

  • Screenshot 2020-12-01 at 16.13.27.png
    Screenshot 2020-12-01 at 16.13.27.png
    116.1 KB · Views: 9
Upvote 0
Do you usually use the comma as a separator in your formulae?
 
Upvote 0
Thanks, changing the commas to ; worked!
Now - how do I use this formula in a clever way if I have like some 1000 projects and 40 columns, thats Data 1 to Data 40?
 
Upvote 0
Just extend the ranges to suit.
 
Upvote 0
I'm afraid I don't know what you mean.
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,162
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top