How to Seperate plan and actuals from the same column

Hi Experts, I have a ask where I need to separate plan and Actual into two different Colum and also change the format from column view to row view.

Please see the attached XL file, the tab "Output" is showing current data set and "Sheet1" is showing desired data set.

Please help.

Thank you in advance for your time and advise/solution.

Dwarkesh T

Data Investigation

Accepted answers

All comments

phottovy

Hi @DwarkeshT,

The attached workflow will only work with "Clerical Payroll" but could be modified if you want to keep other columns as well.

Separate Columns.yxzp

Jonathan-Sherman

Hi @DwarkeshT,

It looks as though you'll want to pivot your data twice (firstly to get each Expense fields into one column, and secondly to separate out actual and plan into separate fields).

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Kind regards,

Jonathan

20210322 - PivotData.yxzp

DwarkeshT

Solved, thank you very much.

messi007

@DwarkeshT,

You need a cross tab in this case:

Hope this helps,

Attached the workflow,

Regards,

DwarkeshT

Thank you everyone, appreciated support. It is resolved.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703