Reformatting column

I have a customer and product listing that displays price, quantity, cost of sales etc for each product purchased by a customer. The original dataset lists the customer then all products purchased underneath, before doing the same for the following customer (see current format below). I want to have one master list where the customer is displayed next to each product purchased (see ideal format further below).

Each customer purchases a different mix and volume of products so there is uniform number of rows between customers.

Current format

	Sales	Cost of sales	Margin
Customer 1
Product A
Product B
Product C
Customer 1 total
Customer 2
Product X
Product Y
Product Z
Customer 2 total

Ideal format

		Sales	Cost of saes	Margin
Customer 1	Product A
Customer 1	Product B
Customer 1	Product C
Customer 2	Product X

Any help would be much appreciated.

Thanks

Datasets

Accepted answers

Christine_Assaad

Hi @Rhys1

Please check the below. Hope it helps. Cheers!

Reformatting column.yxmd

All comments

lcrosby

Hi,

Just to clarify, is the issue that you need to be able to identify which product purchases belong to a specific customer so you can transpose the data?

If so you can do that with a multi-row tool, I can go over it if I'm on the right track.

Thanks,

Leon

Raj_Singh1

Hi @Rhys1

please see attached excel file and workflow. once the value are populated in the excel file the last filter will remove null values and it should look like your desired output.

Please let me know if you have any more questions

thanks

Ideal Format.xlsx

Ideal Format wf.yxmd

Christine_Assaad

Hi @Rhys1

Please check the below. Hope it helps. Cheers!

Reformatting column.yxmd

Rhys1

Thanks everyone for the help - this worked perfectly

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167