Home

Insert new Pivot Tables in Excel Online

Highlighted
iris001
New Contributor

I have an excel spreadsheet with text on 20 lines.

I now need to add a line in between all 20 lines.

Is there an easy way to do this?

2 Replies
Highlighted

@iris001 I'm assuming that you need to enter a blank row between each row of data. You can add a helper column that contains the numbers 1-20 in the rows 2 to 21. Copy this same data and paste it into the rows 22 to 41. Sort the data on this column in the ascending to descending order and you should have a blank row for every row of text. 

Thank you!! Will give it a try.
Related Conversations
Matching date input to the formatted date display
Erikstg in Excel on
1 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
13 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
1 Replies