Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please look at the document and I have two sheets 3 months and 12 months sheet.
I need combine data columns in 3 months sheet and 12 months sheets.
Columns starts from 3 months sheet ShoID, Repair Facility....
Columns starts from 12 months sheet ShoID, Repair Facility....
I want to combine them into one single QVD. There is no time stamp both sheets. How should I combine them into one QVD?
Thaks,
Siva
Hi,
As I said above, your file need transformation before going to the concatenation part, you have merged cells and other excel things. My computer crashed because of it.
you should have structure like this:
dimension1 |
|
|
|
| |||||
---|---|---|---|---|---|---|---|---|---|
value |
|
|
|
| |||||
|
|
|
|
| |||||
|
|
|
|
|