I have not found a way. Normally I cut and paste the other lines under the first line of data.
Thought about anything for transposing on cut and paste but do not think that would work either.
Liz Williamson
Sr. Support Engineer - Clarity
Broadcom
------------------------------
Liz Williamson
Sr. Support Engineer - Clarity
Broadcom
------------------------------
Original Message:
Sent: 04-06-2021 01:24 PM
From: Pam Hughes
Subject: Benefit Plan - How to Export to Excel and keep same Amounts by Period Format
Any suggestions on exporting a Benefit Plan to Excel and keeping the Amounts By Period format as viewed in Clarity intact in the Excel export? Or, is there an easy Excel formula to change the exported cells back to the same view/format as it looks in Clarity? Because the current Benefit Plan export to Excel splits out the Planned Benefits and Realized Benefits into separate columns in Excel which is not as easy to view as the Clarity view below, IMO. Thank you.
Benefit Plan