Need help on data cleaning

[trivi]

Hi all,

I need help with data cleaning I have attached an excel file in it 1st sheet is the input file and 2nd is the output file.

[Luke_C]

 Hi @trivi 

Here's how:

1. Since there are multiple headers, we need to separate them from the data for some processing:
   1. Take first two header rows, add a record ID, transpose, crosstab, and fill down for the shipping mode
2. The data itself just needs to be transposed and have null values removed
3. We can join back on the 'name' field that is a product of the tranpose tool

[trivi]

Thank you so much luke

[Luke_C · Accepted solution]

@trivi No problem, give it a go and be sure to accept the solution if it works for you.