Description
Expands an array by specifying the number of rows and columns for the destination array.
NOTE
- Attempting to narrow the array will return a #VALUE.
- The expected array should not be too large.
- The default value for added cell is #NA.
Syntax
Copied!=EXPAND(array, rows, [columns], [pad_with])
EXAMPLE
Copied!//[𝘰𝘱𝘵𝘪𝘰𝘯𝘢𝘭]: pad_with=[#𝘕𝘈] //𝘤𝘳𝘦𝘢𝘵𝘦 𝘢𝘯 𝘢𝘳𝘳𝘢𝘺 [10𝘳 𝘹 1𝘤] 𝘸𝘪𝘵𝘩 𝘥𝘦𝘧𝘢𝘶𝘭𝘵 𝘷𝘢𝘭𝘶𝘦 =1 =EXPAND({1}, 10, 1, 1) //𝘦𝘹𝘱𝘢𝘯𝘥 𝘵𝘩𝘦 𝘨𝘪𝘷𝘦𝘯 𝘢𝘳𝘳𝘢𝘺 𝘈1:𝘉2 𝘵𝘰 5 𝘳𝘰𝘸𝘴, 3 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘸𝘪𝘵𝘩 𝘢𝘥𝘥𝘦𝘥 𝘷𝘢𝘭𝘶𝘦 = #𝘕𝘈 =EXPAND(A1:B2, 5, 3) //𝘦𝘹𝘱𝘢𝘯𝘥 𝘵𝘩𝘦 𝘨𝘪𝘷𝘦𝘯 𝘢𝘳𝘳𝘢𝘺 𝘈1:𝘈5 𝘵𝘰 3 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘸𝘪𝘵𝘩 𝘢𝘥𝘥𝘦𝘥 𝘷𝘢𝘭𝘶𝘦 = '-' =EXPAND(A1:A5, , 3, "-")