Flipping a set of columns

[Brawlstrogg]

Hi folks,

Having some issue with the Transpose/Cross Tab tools and wondered if I could get some help?

I've got the following setup;

Date	Products	Workarea1	Workarea2	Workarea3	Workarea4	Business Area
01-12-17	Recieved Today	300	100	900	...	Site 1
01-12-17	Done Today	250	25	500	..	Site 1
01-12-17	Done Today (Rej)	25	25	102	...	Site 1
01-12-17	OTS	25	50	..	...	Site 1

That goes down around 7000 rows on an Excel sheet.

I need it to look like the following;

Date	Work Area	Recieved Today	Done Today	Done Today (REJ)	OTS	Business Area
01-12-17	WorkArea1	300	250	25	25	Site 1
01-12-17	WorkArea2	...	...	...	...
01-12-17	WorkArea3
01-12-17	WorkArea4
01-12-17	WorkArea5
01-12-17	WorkArea6
01-12-17	WorkArea7
01-12-17	WorkArea8
01-12-17	WorkArea9

I've been arguing with the Transpose/Cross Tab all morning but can't seem to crack it?

[vishwa_0308 · Accepted solution]

Hi,

Please go through the workflow, it will take you closer to get the result.

[Brawlstrogg]

Hi @vishwa_0308 - We're getting there. On the cross-tab I'm running into an issue where the date becomes NULL and the data literally becomes a mash of all the different sets "0, 6, 12, 18, ..."

Any ideas?

STRIKE THAT

I've got Null dates floating around. Works perfectly mate. Thank you!