Skip to main content
Web Applications

Return to Question

made question focused and about Google Spreadsheets, which is what it's tagged with and what the accepted answer is from
Source Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314

How do I split multiple rows / insert a row below every existing row, in any spreadsheet programGoogle Spreadsheets?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2.

I realized that the algorithm for the lift scheme is slightly flawed, so now I need to record each journey individually, iei.e., I need to split each row in two.

There are already a lot of days on the chart. How can I add a row below each row / iei.e., split every row? Usually rows are added at the end of the spreadsheet.

How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2.

I realized that the algorithm for the lift scheme is slightly flawed, so now I need to record each journey individually, ie I need to split each row in two.

There are already a lot of days on the chart. How can I add a row below each row / ie split every row? Usually rows are added at the end of the spreadsheet.

How do I split multiple rows / insert a row below every existing row in Google Spreadsheets?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2.

I realized that the algorithm for the lift scheme is slightly flawed, so now I need to record each journey individually, i.e., I need to split each row in two.

There are already a lot of days on the chart. How can I add a row below each row / i.e., split every row? Usually rows are added at the end of the spreadsheet.

removed spreadsheet tag
Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195
Source Link
caduceus
caduceus
  • 233
  • 1
  • 3
  • 6

How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2.

I realized that the algorithm for the lift scheme is slightly flawed, so now I need to record each journey individually, ie I need to split each row in two.

There are already a lot of days on the chart. How can I add a row below each row / ie split every row? Usually rows are added at the end of the spreadsheet.