Cross-tab / Transform to organize data

I need the data is Sheet 1 to look like Sheet 2 in the attached excel file.

Workflow

Datasets

Tips and Tricks

Transformation

Help

Accepted answers

Hi @calvincarr29

Step 1:

Step 2:

Step 3:

Step 4:

Many thanks

Shanker V

@calvincarr29 a batch macro approach

ORganize_Data_30042024.yxzp

All comments

Hi @calvincarr29

One way of doing this.

Screenshot 2024-04-30 100103.png

Many thanks

Shanker V

Hi @calvincarr29

Step 1:

Step 2:

Step 3:

Step 4:

Many thanks

Shanker V

@calvincarr29 a batch macro approach

ORganize_Data_30042024.yxzp

Quick Links

Tags

This months top contributors

AkimasaKajitani 390

michael_weaver 335