Need help on Concatenate in pivot

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I uploaded the file. Please let me know if you guys see it.

My desired results are column E to column G. If that is not doable, getting column G is fine too. This is just dummy data. My original file has 1,000 rows I have to concatenate and I want to see if there is a sufficient way of doing it.

Hello klum2015 and Welcome to Excel Forum.
This proposal adds two helper columns (D:E) which may be moved and/or hidden for aesthetic purposes.
The first helper is populated using: =IF(A3<>"",C3,D2&" "&C3)
The second helper is populated using: =IF(C4="",1,0)
Of the result columns the Name and Location columns are populated using: =IF(A3="","",A3)
The Description column is populated using: =IF(H3="","",INDEX(D$3:D$20,AGGREGATE(15,6,(ROW(D$3:D$20)-ROW(D$2))/(E$3:E$20=1),COUNTIFS(H$3:H3,"?*"))))
Let us know if you have any questions.

Thanks for writing me a formula. Can you help understand a little bit more of the formula you have written?

For instance, why is 15 used in the aggregate formula and what is the purpose of the 2nd helper?

Since I have more rows than what is in the spreadsheet, I will have to extend the formula. I try extending the range of the formula but I am not getting results.

Thank you very much.

The 15 is the SMALL function. (See information on AGGREGATE)
The second helper column's purpose is to indicate, with a 1, the rows in which the list of descriptions are completed for each name.
To extend the INDEX/AGGREGATE formula's range change all of the 20's to the maximum number of rows.
I.E. if there are 1000 rows then the formula should read: =IF(H3="","",INDEX(D$3:D$1000,AGGREGATE(15,6,(ROW(D$3:D$1000)-ROW(D$2))/(E$3:E$1000=1),COUNTIFS(H$3:H3,"?*"))))
All other formulas should be copied down as far as the last row containing a description.
Let us know if you have any questions.