google-sheetsgoogle-sheets-formulaunpivot
How can I transpose some specific columns, while repeating first 4 columns using a formula in Google Sheets?
I would need the first 4 columns to have their data repeated, while the others are stacked up, like the example below and whose link can be found here:
Solution
Here's one approach you may test out:
=reduce(tocol(;1);E2:G6;lambda(a;c;vstack(a;hstack(index(A1:D6;row(c));index(A1:G1;column(c));c))))
UPDATED FORMULA:
=reduce(tocol(;1);E2:index(G:G;match(;0/(A:A<>"")));lambda(a;c;vstack(a;hstack(index(A:D;row(c));index(A1:G1;column(c));c))))
- Same code behaving differently inside and outside function
- How to use VLOOKUP() + QUERY() + IMPORTRANGE() with multiple conditions?
- How to find value vertically and horizontally, using formula in Sheets?
- Return SUM of all cells that fit TWO CRITERIA related by POSITION
- Sum column until first empty cell
- Extract Data from Multiple Sheets with Similar Names
- How many time based trigger can your add-on run on a document / user?
- ARRAYFORMULA option for checking for cell values on each row of Google Sheet
- Filter a range by array
- Google Sheet Table in one row
- Google Sheets Import CSV popup
- Calculating Average of last 10 Data Entries while Omitting Zeros
- Fastest way to search for a row in a large Google Sheet using/in Google Apps Script
- Google Apps Script showing previous day
- Automatically transfer data from the same cell in different sheet tabs to one table
- How to use the function .getLastRow() in google script
- Updating appscript dropdown in sidebar after a successful operation
- Getting Range not found when using getRange()
- How to generate an uuid in google sheet?
- Improve performance of onEdit simple trigger
- Query and Importrange function with conditions
- Google Apps Script attempting to utilize OAuthScopes is giving an error with no details and prevents saving
- Why can't I format my dates after they are returned from this function?
- Appscript Google sheets returns null
- RegExtract a value from a comma-separated string
- Conditional formatting if a cell is a duplicate value
- Google Sheets Image() function now requires users to hit Allow Access
- Can I use Google Apps Script instead of Formulas for doing calculations on a spreadsheet?
- Is it possible to display an iframe or webview in google sheets
- In the same Google Sheet Workbook, can you extract the info from a cell in Sheet A to a cell in Sheet B, and link it back to the same cell in Sheet A?