Need help to transpose data and add headings

[ExcelMonkey1]

I am trying to take data from one tab, transpose it into columns on the next tab, but include the headings that go along with each line.

Example one company might have 4 items under Type Cd SS, but another company might have 60, and another might have 0
In order for me to merge these into a letter (in WORD), I need each amount / reference number in its own column.

If I need to put in fixed headings I can, I would just need to have them in order:
CS # ; CS Amt ; SS # ; SS Amt ; TN # ; TN Amt ; STN # ; STN Amt

CS is only 1
SS could be anywhere from 0 - 70
TN could be anywhere from 0 - 5
STN could be anywhere from 0 -5

I am able to transpose the rows into one line per company, but unclear how to bring over the headings so I know what they are, and I can't just have them fixed because if one company has no Type Code CS then it needs to leave it blank, but it enters the next line in the first column.

In the attached file,
Tab - DATA = my information pulled from my system
Tab - Working File1 = information pulled after my transposition macro
Tab - Working File - End Result = what I would like the information to actually look like

(also, if possible to make things easier?? before transposing make any Type Code PRS or SRS to show just SS)

End result, I need to be able to merge into my word document the following information
Company #
Company Name
Full Name
CS #
CS Amount
SS #'s
SS Amounts
TN #'s
TN Amounts
STN #'s
STN Amounts

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[ExcelMonkey1]

Wondering if anyone knows if this is possible?