Report output in excel has merged cells making fuller analysis difficult (e.g. running Pivots)

Jerry Stevens

Organization Name

BT Plc

Description

Merged cells in report output

- ideally the attribute 1 and 2 would repeat for all applicable rows, this would support further analysis of downloaded reports.

Report example
Attribute 1	Attribute 2	Attribute 3
1 value	Value A	value 1
		value 2
		value 3
		value 4
		value 1
	Value B	value 2
		value 3
		value 4
		value 5
		value 10
2 value	Value A	value 2
		value 3
		value 4
		value 5
		value 6
	Value B	value 3
		value 5
		value 9
	Value C	value 4
		value 5
		value 6

Use Case and Business Need

This would enable further analysis of data download both for BIP and OTBI reports adding value for large reports that cannot only be consumed by eye. 

More details

a lot of manipulation is required before the downloaded report can be used for further analysis

Original Idea Number: b8d7177e43