Hello dear community,
I am trying to stack two or more columns from pivot tables(columns/data).
I mean, data should appear from the first column until it is empty/null, then data from the other column should appear, just like a stack of two or more columns, change/refresh dynamically/automatically, in short print/export ready.
For sorting and filtering purpose I am using pivot tables.
Sample calc file is attached. Two sheets are there, first have data/pivot/columns and the second contains the desired result, which I want to done dynamically/automatically. Stacked columns may have min-40 to max-100 row height. When pivot table refreshed (change in height-rows) the second sheet (stacked column/s) should change accordingly.
(Declaration… This is just an example, I don’t want exact result, I need idea/formula.)
stack columns.ods (48.1 KB)
Thanks for your help!! 
Reffered Topics till this post…
- Calc: Way to join/merge multiple data ranges to one
- Calc Question- How Merge Columns
- Calc Question- How Merge Columns
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-IN (en_US); UI: en-US
Calc: CL threaded