Explain a situation where user would transpose data on a spreadsheet in Microsoft Excel. Give at least one example to illustrate your reasoning. Use details to support your answer.
function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and row
