Data arrangements

Dear All,

In the attached excel file you will find two tabs (Current Data & Looks Like) Just i want to know how to make workflow to move the data from different columns to designated column and this column representing the filled data.

Thanks & Regards.

Book1.xlsx

Datasets

Accepted answers

JohnJPS

Hi @Mostafa_Anwar,

I got it as far as ...

... which is pretty straightforward with Transpose and CrossTab with a little twiddling in between.

Perhaps the techniques utilized can get you a step closer to your ultimate goal.

I thought it looked pretty clean as is, though, and perhaps various discrepancies are sample-data-based and not approach-based?

Hope that helps!

John

rearrangeStuff.yxzp

JohnJPS

Hi @Mostafa_Anwar,

Essentially the missing columns are just labels, so you can add them back in with a Formula tool that basically hard-codes them. This has been done in the attached modification here.

rearrangeStuff.yxzp

All comments

JohnJPS

Hi @Mostafa_Anwar,

I got it as far as ...

... which is pretty straightforward with Transpose and CrossTab with a little twiddling in between.

Perhaps the techniques utilized can get you a step closer to your ultimate goal.

I thought it looked pretty clean as is, though, and perhaps various discrepancies are sample-data-based and not approach-based?

Hope that helps!

John

rearrangeStuff.yxzp

Mostafa_Anwar

Thanks @JohnJPS for your respond, Your proposal is awesome, However i want to show the status column as well even if there null rows will be displayed,

Attached is the excel file that i want to display the data as is so appreciate your support here.

Data Look Like.xlsx

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280