Skip to content

Instantly share code, notes, and snippets.

@Shubhayu-Das

Shubhayu-Das/gist:00eb50448900660522165f944f944a64

Created October 11, 2021 06:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Shubhayu-Das/00eb50448900660522165f944f944a64 to your computer and use it in GitHub Desktop.
Save Shubhayu-Das/00eb50448900660522165f944f944a64 to your computer and use it in GitHub Desktop.
Download ZIP
Excel/Libreoffice instruction to merge n rows into a single row
Raw
gistfile1.txt
Drag this formula to all relevant cells, changing the $A$1 to $A$2, $3..., assuming data starts from column A
Change $25 to $n, where n is the number of rows we want to merge
=TRANSPOSE(OFFSET($A$1:$A$25,25*(ROWS($1:1)-1),0))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment