unpivot data and handle merged cells without using Power Query (Unpivot_Toolkit)

The author created two Excel Lambda functions to address data transformation challenges. The UNPIVOT_PLUS function efficiently converts wide data into a long format, suitable for databases. This function takes several arguments, with defaults provided for common use cases. It automatically handles fill-down/fill-right logic for spreadsheets with merged cells. Another function, SPLIT_INJECT, splits specific columns based on a delimiter. This function expands the table horizontally while preserving the other columns. SPLIT_INJECT offers optional arguments similar to the TEXTSPLIT function's defaults. Both functions are accessible through a GitHub Gist, allowing others to use them. The author encourages others to adapt these and seek feedback on their use. The UNPIVOT_PLUS function has pre-set defaults for different scenarios. The functions are designed to streamline data manipulation tasks in Excel. The author aims to simplify common data formatting tasks.