How to create following Pivot table ?
- by Vamshi
Hi!
Can we create pivot table with Multiple columns and each column contains multiple rows.
For example...........
Database Table:
BatchID BatchName Chemical Value
--------------------------------------------------------
BI-1 BN-1 CH-1 1
BI-2 BN-2 CH-2 2
--------------------------------------------------------
This is the table , i need to display like below in Excel Sheet
BI-1 BI-2
BN-1 BN-2
------------------------------------------
CH-1 1 null
------------------------------------------
CH-2 null 2
------------------------------------------
Here BI-1,BN-1 are two rows in a single columns i need to display chemical value as row of that.
Could Please help me to solve this problem.
Thank You.