I have client data that is in rows in a table Example:
Anderson 3 units $5.00 per unit $15.00
Anderson 6 units $18.00 per unit $108.00
Anderson 3 units $3.23 per unit $9.69
I have about 2000 rows. Each client can have anywhere from one row to four rows.
I want to have
Anderson 3 $5.00 6 $18.00 3 $3.23
I want the units and price in different columns all in the same row. I am trying to mail merge the units and cost into a letter. Thanks for any help.
Hi Todd
Please attach a workbook with sample data for us to take a look.
Hello,
I added a sample. I just want one row per client and multiple columns for each service. Clients might have one row, or up to 4 rows. Each service is a different report and I have no control how the reports are produced.
I am using the power query to pull them together.
Thanks for any help..
Hi,
You can get that using Pivot Table. See attached.
Br,
Anders
Thank you very much. I will try it when I get to the office next week.
