Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Formatting in Output

TwylaXBlack
8 - Asteroid

I need to format the output so there is only one cell for the Date field as example below.

 

This is what I have

DateSiteAccessioned VolumeQueueWIPOldest in Queue
2022-09-14Mercury1,915207,37948,940345
2022-09-14Neptune6,4101,298,511974,361939
2022-09-14Mars 1,4641,640,8320
2022-09-14Jupiter502649,5133,498
2022-09-14Earth96,72507560
2022-09-14Saturn4,775020
2022-09-14Venus2,317,601139,735132,1423,376
2022-09-14Total2,427,4761,647,1152,846,5468,158

 

This is what I need it to look like.

 

TwylaXBlack_0-1663196703631.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@TwylaXBlack 
I am not sure there is a stting can be done for that purpose.
and if not , maybe we can do something tricky, like hiding other cells of first of your columns.

TwylaXBlack
8 - Asteroid

I was able to hide some cells and get the date the one time. However, the borders are still there in the date column.

Labels
Top Solution Authors