TOP

Duplicate column

Power Query > Duplicate column

This tool allows you to create an exact copy of the selected column in LibreOffice Calc, automatically inserting it next to the original. The key feature of this function is that it preserves the original links and formulas of the column, which does not happen with regular copy-pasting, making it ideal for use in data processing workflows.

This is useful when you need to create an additional column to perform transformations on it (e.g., remove part of the text or change case), leaving the original data untouched.


Screenshot

Power Query > Duplicate column

After applying:

Power Query > Duplicate column

Launching this tool

Click YLC Utilities > Power Query > Duplicate column :

LibreOffice Calc:

YLC Utilities > Power Query › Duplicate column

How much time will this save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use LO Calc, the volume of data you work with, and how frequently you use this tool.

Download extension

You can use the utility Duplicate column by installing the extension YLC Utilities.

After this, this function will be available in all files opened in LibreOffice Calc.


Additional keywords for this tool:
Duplicate column, copy column, preserve links, Power Query, data transformation

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel