Create Multiple rows from One

[GMonty]

I have a table that looks something like this:

Date           | Shop1 Revenue | Shop2 Revenue | Shop3 Revenue

28/08/2025 | £120                   | £100                  | £40

How can I reformat it to look something like:

Date           | Shop    | Revenue

28/08/2025 | Shop 1 | £120

28/08/2025 | Shop 2 | £100

28/08/2025 | Shop 3 | £40

Thanks!

[Oleg_Troyansky · Accepted solution]

Hi @GMonty ,

Look into the CROSSTABLE load. Or, if you are using Data Manager in Qlik Sense, there is a feature called "Unpivot". Both will allow you to transform your data the way you describe.

Allow me to invite you to my Qlik Expert Class that I'll be teaching in Vienna, Austria on September 22-24. I will be teaching advanced data modeling, covering some of these challenges, along with advanced scripting, performance optimization, and advanced aggregation and Set Analysis techniques. You will learn the most advanced Qlik methodologies that will help you solve tough problems like this one.

Cheers,

Oleg Troyansky