Data is by rows and need to combine it into one row

[iubrownie2]

Please see the attached document.

I have data that could be 1000's of lines of data. However, the report system gives it to me line by line (see tab 1) of sheet.
I would like to combine the data into one row by the persons name, but only need certain fields from the exported report in a specific format. (see sheet 2 for example on how we would like the end result).
I have a tab 3 for the assistance from anyone on how to do it.

Thanks in advance for the help!

[AliGW]

Are you still using Excel 2013, or have you upgraded?

[Glenn Kennedy]

If still using 2013:

=INDEX('exported Data'!J:J,2+5*(ROWS(A$2:A2)-1))&""

copied down, and

=IFERROR(INDEX('exported Data'!$O$2:$O$31,COLUMN(B2)-1+5*(ROWS(B$2:B2)-1)),"")

copied across and down.

[HansDouwe]

If you are updated in the meantime to Excel 365, please try:

Please Login or Register  to view this content.

[iubrownie2]

We are on 365.

[Glenn Kennedy]

Please update your profile now to show O365.

[iubrownie2]

Please update your profile now to show O365.

Done. Thanks for reminding me.

Also, Hans thanks! This worked perfectly. Appreciate it

[Glenn Kennedy]

And did my suggestion work? Hans' is more suitable for O365, so use it... but some acknowledgement of my help might be nice.

[iubrownie2]

Glenn - My apologies. Yes your idea worked as well. Appreciate the help

[Czeslaw]

Power Query

Please Login or Register  to view this content.